﻿CREATE TABLE [dbo].[User]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [LastName] NVARCHAR(50) NOT NULL, 
    [FirstName] NVARCHAR(50) NOT NULL, 
    [Password] NVARCHAR(100) NOT NULL, 
    [Email] NVARCHAR(50) NOT NULL, 
    [Role] NVARCHAR(50) NOT NULL, 
    [IsEnabled] BIT NOT NULL, 
    [Description] VARCHAR(MAX) NULL, 
    [AddDate] DATETIME NOT NULL DEFAULT getdate(), 
    CONSTRAINT [AK_User_Email] UNIQUE ([Email])
)
